If I have the following SQL:
update clients set credits = credits - 1
If this is repeatedly executed, can there ever be a case where concurrency could occur. In other words, does MySQL cater for concurrency internally, or could this cause issues if the sql is executed concurrently by multiple parties?